/*
 Navicat Premium Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 50728
 Source Host           : localhost:3306
 Source Schema         : mxg_member

 Target Server Type    : MySQL
 Target Server Version : 50728
 File Encoding         : 65001
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tb_goods
-- ----------------------------
DROP TABLE IF EXISTS `tb_goods`;
CREATE TABLE `tb_goods` (
  `id` int(40) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(100) DEFAULT NULL COMMENT '商品名称',
  `code` varchar(100) DEFAULT NULL COMMENT '商品编码',
  `spec` varchar(100) DEFAULT NULL COMMENT '商品规格',
  `retail_price` decimal(10,2) DEFAULT NULL COMMENT '零售价',
  `purchase_price` decimal(10,2) DEFAULT NULL COMMENT '进货价',
  `storage_num` int(10) DEFAULT NULL COMMENT '库存数量',
  `supplier_id` int(40) DEFAULT NULL COMMENT '供应商id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='商品信息表';

-- ----------------------------
-- Records of tb_goods
-- ----------------------------
BEGIN;
INSERT INTO `tb_goods` VALUES (1, 'SpringBoot全家桶', 'springboot', '200课时', 399.00, 299.00, 100000, 1);
INSERT INTO `tb_goods` VALUES (2, 'SpringSecurityOauth2', 'oauth2', '300课时', 499.00, 399.00, 10, 1);
INSERT INTO `tb_goods` VALUES (3, '最新款iphone', 'iphone', '138mm', 5999.00, 3999.00, 10000, 0);
INSERT INTO `tb_goods` VALUES (4, 'springcloud分布式教程', 'springcloud', '', 10.00, 0.00, 0, 1);
COMMIT;

-- ----------------------------
-- Table structure for tb_member
-- ----------------------------
DROP TABLE IF EXISTS `tb_member`;
CREATE TABLE `tb_member` (
  `id` int(40) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `card_num` varchar(30) DEFAULT NULL COMMENT '会员卡号',
  `name` varchar(100) DEFAULT NULL COMMENT '会员姓名',
  `birthday` datetime DEFAULT NULL COMMENT '会员生日',
  `phone` varchar(30) DEFAULT NULL COMMENT '手机号码',
  `integral` int(11) DEFAULT NULL COMMENT '开卡金额',
  `money` decimal(11,2) DEFAULT NULL COMMENT '可用积分',
  `pay_type` char(2) DEFAULT NULL COMMENT '支付类型（''1''现金, ''2''微信, ''3''支付宝, ''4''银行卡）',
  `address` varchar(255) DEFAULT NULL COMMENT '会员地址',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COMMENT='会员信息表';

-- ----------------------------
-- Records of tb_member
-- ----------------------------
BEGIN;
INSERT INTO `tb_member` VALUES (1, 'meng001', '1号小梦', '1790-05-25 09:40:36', '15000000001', 0, 10.00, '1', '北京软件产业园');
INSERT INTO `tb_member` VALUES (2, 'meng002', '2号小梦', '2001-02-08 08:00:00', '15000000002', 90, 100.00, '3', '上海软件产业园');
INSERT INTO `tb_member` VALUES (3, 'meng003', '3号小梦', '2001-02-08 08:00:00', '15000000003', 190, 100.00, '2', '深圳软件产业园');
INSERT INTO `tb_member` VALUES (4, 'meng004', '4号小梦', '2001-02-08 08:00:00', '15000000004', 290, 100.00, '3', '广州软件产业园');
INSERT INTO `tb_member` VALUES (5, 'meng005', '老司机', '2001-02-08 08:00:00', '15000000005', 390, 100.00, '1', '杭州软件产业园');
COMMIT;

-- ----------------------------
-- Table structure for tb_staff
-- ----------------------------
DROP TABLE IF EXISTS `tb_staff`;
CREATE TABLE `tb_staff` (
  `id` int(40) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `username` varchar(100) DEFAULT NULL COMMENT '帐号',
  `password` varchar(100) DEFAULT NULL COMMENT '密码',
  `name` varchar(100) DEFAULT NULL COMMENT '姓名',
  `age` int(11) DEFAULT NULL COMMENT '年龄',
  `mobile` varchar(30) DEFAULT NULL COMMENT '电话',
  `salary` decimal(11,2) DEFAULT NULL COMMENT '薪酬',
  `entryDate` datetime DEFAULT NULL COMMENT '入职时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='员工信息表';

-- ----------------------------
-- Records of tb_staff
-- ----------------------------
BEGIN;
INSERT INTO `tb_staff` VALUES (1, 'admin', '$2a$10$xqY4cqA8mj7MVipMrlt5aOGSMd1OBcktsugsuf6Sc0oHzWAH73lSi', '管理员', 18, '199999977', 10000.00, '2016-03-07 08:00:00');
INSERT INTO `tb_staff` VALUES (3, 'meng', '$2a$10$uA51hWL5yusFBoEvZOAZbeaYYqUaFV7xjdDB8GA.4iViNiCSK9xKO', '小梦', 19, '19999999999', 20000.00, '2017-03-07 08:00:00');
INSERT INTO `tb_staff` VALUES (4, 'test', '$2a$10$uA51hWL5yusFBoEvZOAZbeaYYqUaFV7xjdDB8GA.4iViNiCSK9xKO', '测试', 39, '19999999988', 30000.00, '2016-03-07 08:00:00');
COMMIT;

-- ----------------------------
-- Table structure for tb_supplier
-- ----------------------------
DROP TABLE IF EXISTS `tb_supplier`;
CREATE TABLE `tb_supplier` (
  `id` int(40) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(100) DEFAULT NULL COMMENT '供应商名称',
  `linkman` varchar(100) DEFAULT NULL COMMENT '联系人',
  `mobile` varchar(30) DEFAULT NULL COMMENT '联系电话',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COMMENT='供应商信息表';

-- ----------------------------
-- Records of tb_supplier
-- ----------------------------
BEGIN;
INSERT INTO `tb_supplier` VALUES (0, '阿里巴巴集团', ' 老马', '18888888888', '聚万物之所有，只有你想不到');
INSERT INTO `tb_supplier` VALUES (1, '梦学谷科技', '梦老师', '16666666666', '高品质IT在线教育提供商');
INSERT INTO `tb_supplier` VALUES (2, '梦学谷在线教育', '老梦', '177777777777', '专注一直被模仿');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
